Resolve Excel scatterplots misinterpreting multiple data series by manually mapping X and Y values in the Select Data Source dialog.